Overview

Dataset statistics

Number of variables	27
Number of observations	5840
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	4
Duplicate rows (%)	0.1%
Total size in memory	513.4 KiB
Average record size in memory	90.0 B

Variable types

Numeric	9
Boolean	18

Alerts

Dataset has 4 (0.1%) duplicate rows	Duplicates
`fuel_Diesel` is highly overall correlated with `fuel_Petrol` and 1 other fields	High correlation
`fuel_Petrol` is highly overall correlated with `fuel_Diesel` and 1 other fields	High correlation
`km_driven` is highly overall correlated with `km_driven_squared` and 2 other fields	High correlation
`km_driven_squared` is highly overall correlated with `km_driven` and 2 other fields	High correlation
`max_power` is highly overall correlated with `name` and 3 other fields	High correlation
`max_torque_rpm` is highly overall correlated with `fuel_Diesel` and 2 other fields	High correlation
`mileage` is highly overall correlated with `seats_5`	High correlation
`name` is highly overall correlated with `max_power` and 3 other fields	High correlation
`seats_4` is highly overall correlated with `max_power`	High correlation
`seats_5` is highly overall correlated with `mileage` and 1 other fields	High correlation
`seats_7` is highly overall correlated with `seats_5`	High correlation
`torque` is highly overall correlated with `max_power` and 2 other fields	High correlation
`transmission_Manual` is highly overall correlated with `max_power`	High correlation
`year` is highly overall correlated with `km_driven` and 3 other fields	High correlation
`year_squared` is highly overall correlated with `km_driven` and 3 other fields	High correlation
`fuel_LPG` is highly imbalanced (94.8%)	Imbalance
`seller_type_Individual` is highly imbalanced (51.3%)	Imbalance
`seller_type_Trustmark Dealer` is highly imbalanced (96.0%)	Imbalance
`transmission_Manual` is highly imbalanced (57.6%)	Imbalance
`owner_Fourth & Above Owner` is highly imbalanced (83.7%)	Imbalance
`owner_Test Drive Car` is highly imbalanced (99.2%)	Imbalance
`owner_Third Owner` is highly imbalanced (60.6%)	Imbalance
`seats_4` is highly imbalanced (88.1%)	Imbalance
`seats_6` is highly imbalanced (93.1%)	Imbalance
`seats_8` is highly imbalanced (79.2%)	Imbalance
`seats_9` is highly imbalanced (90.8%)	Imbalance
`seats_10` is highly imbalanced (97.0%)	Imbalance
`seats_14` is highly imbalanced (99.8%)	Imbalance
`km_driven_squared` is highly skewed (γ1 = 62.45997268)	Skewed

Reproduction

Analysis started	2025-12-04 01:02:06.586846
Analysis finished	2025-12-04 01:02:11.444273
Duration	4.86 seconds
Software version	ydata-profiling vv4.18.0
Download configuration	config.json

mileage
Real number (ℝ)

High correlation

Distinct	376
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.430841

Minimum	0
Maximum	42
Zeros	14
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	0
5-th percentile	12.8285
Q1	16.95
median	19.37
Q3	22.3
95-th percentile	25.8
Maximum	42
Range	42
Interquartile range (IQR)	5.35

Descriptive statistics

Standard deviation	3.9859732
Coefficient of variation (CV)	0.20513642
Kurtosis	0.87209172
Mean	19.430841
Median Absolute Deviation (MAD)	2.63
Skewness	-0.17505703
Sum	113476.11
Variance	15.887982
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.37	186	3.2%
18.9	175	3.0%
19.7	137	2.3%
18.6	126	2.2%
21.1	118	2.0%
17	105	1.8%
15.96	95	1.6%
17.8	90	1.5%
16.1	84	1.4%
15.1	76	1.3%
Other values (366)	4648	79.6%

Value	Count	Frequency (%)
0	14	0.2%
9	4	0.1%
9.5	1	< 0.1%
10	2	< 0.1%
10.1	2	< 0.1%
10.5	14	0.2%
10.71	1	< 0.1%
10.75	1	< 0.1%
10.8	1	< 0.1%
10.9	4	0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
33.44	2	< 0.1%
33	1	< 0.1%
32.52	1	< 0.1%
30.46	2	< 0.1%
28.4	70	1.2%
28.09	29	0.5%
27.62	5	0.1%
27.4	4	0.1%
27.39	20	0.3%

max_power
Real number (ℝ)

High correlation

Distinct	313
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	87.892354

Minimum	0
Maximum	400
Zeros	4
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	0
5-th percentile	47.3
Q1	68
median	81.86
Q3	99
95-th percentile	147.9
Maximum	400
Range	400
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	31.661223
Coefficient of variation (CV)	0.36022728
Kurtosis	6.0363004
Mean	87.892354
Median Absolute Deviation (MAD)	14.81
Skewness	1.793812
Sum	513291.35
Variance	1002.433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81.86	287	4.9%
74	260	4.5%
88.5	163	2.8%
67	130	2.2%
46.3	127	2.2%
67.1	117	2.0%
62.1	116	2.0%
81.8	115	2.0%
67.04	115	2.0%
70	110	1.9%
Other values (303)	4300	73.6%

Value	Count	Frequency (%)
0	4	0.1%
32.8	2	< 0.1%
34.2	17	0.3%
35	14	0.2%
35.5	2	< 0.1%
37	69	1.2%
37.48	7	0.1%
37.5	6	0.1%
38	1	< 0.1%
38.4	2	< 0.1%

Value	Count	Frequency (%)
400	1	< 0.1%
282	1	< 0.1%
280	1	< 0.1%
272	1	< 0.1%
270.9	3	0.1%
265	1	< 0.1%
261.4	4	0.1%
258	2	< 0.1%
254.8	3	0.1%
254.79	1	< 0.1%

torque
Real number (ℝ)

High correlation

Distinct	240
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	175.36266

Minimum	47.088
Maximum	1863.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	47.088
5-th percentile	69
Q1	111.8
median	160
Q3	200.124
95-th percentile	330
Maximum	1863.9
Range	1816.812
Interquartile range (IQR)	88.324

Descriptive statistics

Standard deviation	107.16174
Coefficient of variation (CV)	0.6110864
Kurtosis	50.367813
Mean	175.36266
Median Absolute Deviation (MAD)	47
Skewness	4.9916845
Sum	1024118
Variance	11483.638
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	503	8.6%
190	454	7.8%
160	326	5.6%
90	297	5.1%
114	191	3.3%
113	148	2.5%
62	130	2.2%
250	110	1.9%
330	101	1.7%
69	101	1.7%
Other values (230)	3479	59.6%

Value	Count	Frequency (%)
47.088	1	< 0.1%
48	1	< 0.1%
51	13	0.2%
55.917	1	< 0.1%
57	2	< 0.1%
58.86	1	< 0.1%
59	85	1.5%
59.841	12	0.2%
60	2	< 0.1%
62	130	2.2%

Value	Count	Frequency (%)
1863.9	1	< 0.1%
1422.45	9	0.2%
1275.3	3	0.1%
1128.15	5	0.1%
1079.1	1	< 0.1%
789	3	0.1%
640	1	< 0.1%
620	6	0.1%
619	3	0.1%
600	3	0.1%

max_torque_rpm
Real number (ℝ)

High correlation

Distinct	46
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3045.789

Minimum	1400
Maximum	21800
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	1400
5-th percentile	1750
Q1	2250
median	3000
Q3	4000
95-th percentile	4500
Maximum	21800
Range	20400
Interquartile range (IQR)	1750

Descriptive statistics

Standard deviation	911.03932
Coefficient of variation (CV)	0.29911439
Kurtosis	29.477441
Mean	3045.789
Median Absolute Deviation (MAD)	750
Skewness	1.6483615
Sum	17787408
Variance	829992.65
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
4000	738	12.6%
3000	686	11.7%
2000	657	11.2%
3500	566	9.7%
2500	457	7.8%
1750	430	7.4%
2750	349	6.0%
2800	313	5.4%
4200	191	3.3%
4500	182	3.1%
Other values (36)	1271	21.8%

Value	Count	Frequency (%)
1400	2	< 0.1%
1500	64	1.1%
1600	1	< 0.1%
1740	1	< 0.1%
1750	430	7.4%
1800	38	0.7%
1850	1	< 0.1%
1900	44	0.8%
2000	657	11.2%
2200	140	2.4%

Value	Count	Frequency (%)
21800	1	< 0.1%
5300	1	< 0.1%
5200	1	< 0.1%
5000	22	0.4%
4850	18	0.3%
4800	75	1.3%
4750	7	0.1%
4700	8	0.1%
4600	51	0.9%
4500	182	3.1%

name
Real number (ℝ)

High correlation

Distinct	2933
Distinct (%)	50.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	499400.64

Minimum	30000
Maximum	6373000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	30000
5-th percentile	124349.87
Q1	273749.94
median	479924.2
Q3	574113.64
95-th percentile	1000000
Maximum	6373000
Range	6343000
Interquartile range (IQR)	300363.69

Descriptive statistics

Standard deviation	422914.85
Coefficient of variation (CV)	0.84684483
Kurtosis	65.19333
Mean	499400.64
Median Absolute Deviation (MAD)	160000
Skewness	6.2761005
Sum	2.9164997 × 10⁹
Variance	1.7885697 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
522960.0911	912	15.6%
200000	34	0.6%
500000	33	0.6%
350000	33	0.6%
400000	31	0.5%
700000	30	0.5%
250000	29	0.5%
300000	28	0.5%
600000	27	0.5%
650000	27	0.5%
Other values (2923)	4656	79.7%

Value	Count	Frequency (%)
30000	1	< 0.1%
35000	1	< 0.1%
40000	1	< 0.1%
42000	1	< 0.1%
45000	3	0.1%
46250	1	< 0.1%
48750	1	< 0.1%
50000	1	< 0.1%
50500.30769	1	< 0.1%
52500	2	< 0.1%

Value	Count	Frequency (%)
6373000	1	< 0.1%
6223000	1	< 0.1%
6073000	1	< 0.1%
6000000	1	< 0.1%
5943333.333	1	< 0.1%
5850000	1	< 0.1%
5833333.333	1	< 0.1%
5800000	1	< 0.1%
5776666.667	2	< 0.1%
5650000	2	< 0.1%

fuel_Diesel
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

True	3177
False	2663

Value	Count	Frequency (%)
True	3177	54.4%
False	2663	45.6%

fuel_LPG
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5806
True	34

Value	Count	Frequency (%)
False	5806	99.4%
True	34	0.6%

fuel_Petrol
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	3261
True	2579

Value	Count	Frequency (%)
False	3261	55.8%
True	2579	44.2%

seller_type_Individual
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

True	5223
False	617

Value	Count	Frequency (%)
True	5223	89.4%
False	617	10.6%

seller_type_Trustmark Dealer
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5815
True	25

Value	Count	Frequency (%)
False	5815	99.6%
True	25	0.4%

transmission_Manual
Boolean

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

True	5336
False	504

Value	Count	Frequency (%)
True	5336	91.4%
False	504	8.6%

owner_Fourth & Above Owner
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5700
True	140

Value	Count	Frequency (%)
False	5700	97.6%
True	140	2.4%

owner_Second Owner
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	4201
True	1639

Value	Count	Frequency (%)
False	4201	71.9%
True	1639	28.1%

owner_Test Drive Car
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5836
True	4

Value	Count	Frequency (%)
False	5836	99.9%
True	4	0.1%

owner_Third Owner
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5386
True	454

Value	Count	Frequency (%)
False	5386	92.2%
True	454	7.8%

seats_4
Boolean

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5746
True	94

Value	Count	Frequency (%)
False	5746	98.4%
True	94	1.6%

seats_5
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

True	4618
False	1222

Value	Count	Frequency (%)
True	4618	79.1%
False	1222	20.9%

seats_6
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5792
True	48

Value	Count	Frequency (%)
False	5792	99.2%
True	48	0.8%

seats_7
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5040
True	800

Value	Count	Frequency (%)
False	5040	86.3%
True	800	13.7%

seats_8
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5649
True	191

Value	Count	Frequency (%)
False	5649	96.7%
True	191	3.3%

seats_9
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5772
True	68

Value	Count	Frequency (%)
False	5772	98.8%
True	68	1.2%

seats_10
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5822
True	18

Value	Count	Frequency (%)
False	5822	99.7%
True	18	0.3%

seats_14
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

False	5839
True	1

Value	Count	Frequency (%)
False	5839	> 99.9%
True	1	< 0.1%

year
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.4284

Minimum	1983
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	1983
5-th percentile	2006
Q1	2011
median	2014
Q3	2017
95-th percentile	2019
Maximum	2020
Range	37
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.0956219
Coefficient of variation (CV)	0.0020341532
Kurtosis	1.692979
Mean	2013.4284
Median Absolute Deviation (MAD)	3
Skewness	-1.0194703
Sum	11758422
Variance	16.774119
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2017	666	11.4%
2016	596	10.2%
2015	568	9.7%
2018	522	8.9%
2012	507	8.7%
2014	480	8.2%
2013	478	8.2%
2011	461	7.9%
2010	322	5.5%
2019	298	5.1%
Other values (19)	942	16.1%

Value	Count	Frequency (%)
1983	1	< 0.1%
1991	1	< 0.1%
1994	3	0.1%
1995	1	< 0.1%
1996	3	0.1%
1997	10	0.2%
1998	9	0.2%
1999	12	0.2%
2000	19	0.3%
2001	7	0.1%

Value	Count	Frequency (%)
2020	58	1.0%
2019	298	5.1%
2018	522	8.9%
2017	666	11.4%
2016	596	10.2%
2015	568	9.7%
2014	480	8.2%
2013	478	8.2%
2012	507	8.7%
2011	461	7.9%

km_driven
Real number (ℝ)

High correlation

Distinct	827
Distinct (%)	14.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73952.242

Minimum	1
Maximum	2360457
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	1
5-th percentile	11000
Q1	39000
median	70000
Q3	100000
95-th percentile	156041
Maximum	2360457
Range	2360456
Interquartile range (IQR)	61000

Descriptive statistics

Standard deviation	60071.137
Coefficient of variation (CV)	0.81229635
Kurtosis	416.02464
Mean	73952.242
Median Absolute Deviation (MAD)	30000
Skewness	12.645506
Sum	4.318811 × 10⁸
Variance	3.6085414 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120000	429	7.3%
80000	356	6.1%
70000	350	6.0%
60000	327	5.6%
50000	305	5.2%
100000	279	4.8%
90000	262	4.5%
40000	227	3.9%
110000	225	3.9%
30000	184	3.2%
Other values (817)	2896	49.6%

Value	Count	Frequency (%)
1	1	< 0.1%
1000	5	0.1%
1300	1	< 0.1%
1303	1	< 0.1%
1500	2	< 0.1%
1600	1	< 0.1%
1620	1	< 0.1%
2000	6	0.1%
2118	1	< 0.1%
2136	1	< 0.1%

Value	Count	Frequency (%)
2360457	1	< 0.1%
1500000	1	< 0.1%
577414	1	< 0.1%
500000	2	< 0.1%
475000	1	< 0.1%
440000	1	< 0.1%
426000	1	< 0.1%
380000	1	< 0.1%
376412	1	< 0.1%
370000	1	< 0.1%

year_squared
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4053910.8

Minimum	3932289
Maximum	4080400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	3932289
5-th percentile	4024036
Q1	4044121
median	4056196
Q3	4068289
95-th percentile	4076361
Maximum	4080400
Range	148111
Interquartile range (IQR)	24168

Descriptive statistics

Standard deviation	16475.411
Coefficient of variation (CV)	0.0040640783
Kurtosis	1.6549167
Mean	4053910.8
Median Absolute Deviation (MAD)	12075
Skewness	-1.0113861
Sum	2.3674839 × 10¹⁰
Variance	2.7143917 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
4068289	666	11.4%
4064256	596	10.2%
4060225	568	9.7%
4072324	522	8.9%
4048144	507	8.7%
4056196	480	8.2%
4052169	478	8.2%
4044121	461	7.9%
4040100	322	5.5%
4076361	298	5.1%
Other values (19)	942	16.1%

Value	Count	Frequency (%)
3932289	1	< 0.1%
3964081	1	< 0.1%
3976036	3	0.1%
3980025	1	< 0.1%
3984016	3	0.1%
3988009	10	0.2%
3992004	9	0.2%
3996001	12	0.2%
4000000	19	0.3%
4004001	7	0.1%

Value	Count	Frequency (%)
4080400	58	1.0%
4076361	298	5.1%
4072324	522	8.9%
4068289	666	11.4%
4064256	596	10.2%
4060225	568	9.7%
4056196	480	8.2%
4052169	478	8.2%
4048144	507	8.7%
4044121	461	7.9%

km_driven_squared
Real number (ℝ)

High correlation Skewed

Distinct	827
Distinct (%)	14.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.0768577 × 10⁹

Minimum	1
Maximum	5.5717572 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1.21 × 10⁸
Q1	1.521 × 10⁹
median	4.9 × 10⁹
Q3	1 × 10¹⁰
95-th percentile	2.4348794 × 10¹⁰
Maximum	5.5717572 × 10¹²
Range	5.5717572 × 10¹²
Interquartile range (IQR)	8.479 × 10⁹

Descriptive statistics

Standard deviation	7.9544179 × 10¹⁰
Coefficient of variation (CV)	8.7634049
Kurtosis	4205.345
Mean	9.0768577 × 10⁹
Median Absolute Deviation (MAD)	3.675 × 10⁹
Skewness	62.459973
Sum	5.3008849 × 10¹³
Variance	6.3272764 × 10²¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.44 × 10¹⁰	429	7.3%
6400000000	356	6.1%
4900000000	350	6.0%
3600000000	327	5.6%
2500000000	305	5.2%
1 × 10¹⁰	279	4.8%
8100000000	262	4.5%
1600000000	227	3.9%
1.21 × 10¹⁰	225	3.9%
900000000	184	3.2%
Other values (817)	2896	49.6%

Value	Count	Frequency (%)
1	1	< 0.1%
1000000	5	0.1%
1690000	1	< 0.1%
1697809	1	< 0.1%
2250000	2	< 0.1%
2560000	1	< 0.1%
2624400	1	< 0.1%
4000000	6	0.1%
4485924	1	< 0.1%
4562496	1	< 0.1%

Value	Count	Frequency (%)
5.571757249 × 10¹²	1	< 0.1%
2.25 × 10¹²	1	< 0.1%
3.334069274 × 10¹¹	1	< 0.1%
2.5 × 10¹¹	2	< 0.1%
2.25625 × 10¹¹	1	< 0.1%
1.936 × 10¹¹	1	< 0.1%
1.81476 × 10¹¹	1	< 0.1%
1.444 × 10¹¹	1	< 0.1%
1.416859937 × 10¹¹	1	< 0.1%
1.369 × 10¹¹	1	< 0.1%

Interactions

Correlations

	fuel_Diesel	fuel_LPG	fuel_Petrol	km_driven	km_driven_squared	max_power	max_torque_rpm	mileage	name	owner_Fourth & Above Owner	owner_Second Owner	owner_Test Drive Car	owner_Third Owner	seats_10	seats_14	seats_4	seats_5	seats_6	seats_7	seats_8	seats_9	seller_type_Individual	seller_type_Trustmark Dealer	torque	transmission_Manual	year	year_squared
fuel_Diesel	1.000	0.080	0.971	0.069	0.002	0.257	0.808	0.334	0.264	0.000	0.039	0.018	0.000	0.046	0.000	0.116	0.311	0.010	0.306	0.114	0.097	0.022	0.052	0.402	0.006	0.200	0.200
fuel_LPG	0.080	1.000	0.064	0.000	0.000	0.061	0.040	0.062	0.000	0.000	0.007	0.000	0.000	0.000	0.000	0.000	0.034	0.000	0.024	0.000	0.000	0.000	0.000	0.000	0.014	0.116	0.116
fuel_Petrol	0.971	0.064	1.000	0.074	0.003	0.240	0.799	0.355	0.252	0.000	0.044	0.019	0.000	0.044	0.000	0.114	0.301	0.005	0.296	0.111	0.094	0.012	0.054	0.389	0.019	0.198	0.198
km_driven	0.069	0.000	0.074	1.000	1.000	0.041	-0.321	-0.198	-0.168	0.051	0.026	0.000	0.029	0.010	0.000	0.000	0.115	0.000	0.089	0.082	0.000	0.022	0.000	0.243	0.016	-0.570	-0.570
km_driven_squared	0.002	0.000	0.003	1.000	1.000	0.041	-0.321	-0.198	-0.168	0.000	0.013	0.000	0.000	0.000	0.000	0.000	0.019	0.000	0.028	0.000	0.000	0.000	0.000	0.243	0.000	-0.570	-0.570
max_power	0.257	0.061	0.240	0.041	0.041	1.000	-0.025	-0.308	0.588	0.035	0.062	0.104	0.044	0.045	0.000	0.778	0.348	0.022	0.327	0.159	0.048	0.212	0.048	0.779	0.513	0.166	0.166
max_torque_rpm	0.808	0.040	0.799	-0.321	-0.321	-0.025	1.000	-0.177	-0.137	0.032	0.080	0.029	0.055	0.039	0.000	0.053	0.298	0.000	0.245	0.100	0.081	0.000	0.067	-0.526	0.051	0.077	0.077
mileage	0.334	0.062	0.355	-0.198	-0.198	-0.308	-0.177	1.000	-0.015	0.068	0.105	0.037	0.100	0.111	0.060	0.216	0.600	0.119	0.437	0.288	0.188	0.058	0.000	-0.162	0.249	0.346	0.346
name	0.264	0.000	0.252	-0.168	-0.168	0.588	-0.137	-0.015	1.000	0.045	0.091	0.472	0.076	0.000	0.000	0.132	0.256	0.000	0.309	0.025	0.000	0.177	0.021	0.559	0.348	0.541	0.541
owner_Fourth & Above Owner	0.000	0.000	0.000	0.051	0.000	0.035	0.032	0.068	0.045	1.000	0.096	0.000	0.041	0.000	0.000	0.026	0.000	0.000	0.013	0.021	0.000	0.050	0.000	0.000	0.023	0.222	0.222
owner_Second Owner	0.039	0.007	0.044	0.026	0.013	0.062	0.080	0.105	0.091	0.096	1.000	0.000	0.180	0.000	0.000	0.028	0.004	0.000	0.000	0.014	0.010	0.113	0.016	0.022	0.047	0.297	0.297
owner_Test Drive Car	0.018	0.000	0.019	0.000	0.000	0.104	0.029	0.037	0.472	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.064	0.000	0.017	0.072	0.023	0.023
owner_Third Owner	0.000	0.000	0.000	0.029	0.000	0.044	0.055	0.100	0.076	0.041	0.180	0.000	1.000	0.000	0.000	0.017	0.000	0.019	0.015	0.024	0.000	0.092	0.005	0.062	0.050	0.272	0.272
seats_10	0.046	0.000	0.044	0.010	0.000	0.045	0.039	0.111	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.103	0.000	0.012	0.000	0.000	0.005	0.000	0.285	0.000	0.036	0.036
seats_14	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.060	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
seats_4	0.116	0.000	0.114	0.000	0.000	0.778	0.053	0.216	0.132	0.026	0.028	0.000	0.017	0.000	0.000	1.000	0.247	0.000	0.047	0.015	0.000	0.000	0.000	0.141	0.000	0.348	0.348
seats_5	0.311	0.034	0.301	0.115	0.019	0.348	0.298	0.600	0.256	0.000	0.004	0.000	0.000	0.103	0.000	0.247	1.000	0.174	0.774	0.356	0.209	0.038	0.020	0.347	0.000	0.109	0.109
seats_6	0.010	0.000	0.005	0.000	0.000	0.022	0.000	0.119	0.000	0.000	0.000	0.000	0.019	0.000	0.000	0.000	0.174	1.000	0.031	0.000	0.000	0.018	0.000	0.000	0.021	0.076	0.076
seats_7	0.306	0.024	0.296	0.089	0.028	0.327	0.245	0.437	0.309	0.013	0.000	0.000	0.015	0.012	0.000	0.047	0.774	0.031	1.000	0.071	0.039	0.000	0.007	0.371	0.010	0.132	0.132
seats_8	0.114	0.000	0.111	0.082	0.000	0.159	0.100	0.288	0.025	0.021	0.014	0.000	0.024	0.000	0.000	0.015	0.356	0.000	0.071	1.000	0.008	0.012	0.000	0.072	0.004	0.072	0.072
seats_9	0.097	0.000	0.094	0.000	0.000	0.048	0.081	0.188	0.000	0.000	0.010	0.000	0.000	0.000	0.000	0.000	0.209	0.000	0.039	0.008	1.000	0.026	0.000	0.048	0.028	0.045	0.045
seller_type_Individual	0.022	0.000	0.012	0.022	0.000	0.212	0.000	0.058	0.177	0.050	0.113	0.064	0.092	0.005	0.000	0.000	0.038	0.018	0.000	0.012	0.026	1.000	0.186	0.087	0.210	0.150	0.150
seller_type_Trustmark Dealer	0.052	0.000	0.054	0.000	0.000	0.048	0.067	0.000	0.021	0.000	0.016	0.000	0.005	0.000	0.000	0.000	0.020	0.000	0.007	0.000	0.000	0.186	1.000	0.000	0.048	0.041	0.041
torque	0.402	0.000	0.389	0.243	0.243	0.779	-0.526	-0.162	0.559	0.000	0.022	0.017	0.062	0.285	0.000	0.141	0.347	0.000	0.371	0.072	0.048	0.087	0.000	1.000	0.362	0.102	0.102
transmission_Manual	0.006	0.014	0.019	0.016	0.000	0.513	0.051	0.249	0.348	0.023	0.047	0.072	0.050	0.000	0.000	0.000	0.000	0.021	0.010	0.004	0.028	0.210	0.048	0.362	1.000	0.153	0.153
year	0.200	0.116	0.198	-0.570	-0.570	0.166	0.077	0.346	0.541	0.222	0.297	0.023	0.272	0.036	0.000	0.348	0.109	0.076	0.132	0.072	0.045	0.150	0.041	0.102	0.153	1.000	1.000
year_squared	0.200	0.116	0.198	-0.570	-0.570	0.166	0.077	0.346	0.541	0.222	0.297	0.023	0.272	0.036	0.000	0.348	0.109	0.076	0.132	0.072	0.045	0.150	0.041	0.102	0.153	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	mileage	max_power	torque	max_torque_rpm	name	fuel_Diesel	fuel_LPG	fuel_Petrol	seller_type_Individual	seller_type_Trustmark Dealer	transmission_Manual	owner_Fourth & Above Owner	owner_Second Owner	owner_Test Drive Car	owner_Third Owner	seats_4	seats_5	seats_6	seats_7	seats_8	seats_9	seats_10	seats_14	year	km_driven	year_squared	km_driven_squared
0	23.40	74.00	190.000	2000.0	586088.833333	True	False	False	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2014	145500	4056196	21170250000
1	21.14	103.52	250.000	2500.0	625000.000000	True	False	False	True	False	True	False	True	False	False	False	True	False	False	False	False	False	False	2014	120000	4056196	14400000000
2	23.00	90.00	219.744	2750.0	522960.091096	True	False	False	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2010	127000	4040100	16129000000
3	16.10	88.20	112.815	4500.0	170000.000000	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2007	120000	4028049	14400000000
4	20.14	81.86	113.750	4000.0	500000.000000	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2017	45000	4068289	2025000000
5	17.30	57.50	76.518	4500.0	146250.000000	False	True	False	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2007	175000	4028049	30625000000
6	16.10	37.00	59.000	2500.0	522960.091096	False	False	True	True	False	True	False	True	False	False	True	False	False	False	False	False	False	False	2001	5000	4004001	25000000
7	23.59	67.10	170.000	2400.0	350000.000000	True	False	False	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2011	90000	4044121	8100000000
8	20.00	68.10	160.000	2000.0	264285.571429	True	False	False	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2013	169000	4052169	28561000000
9	19.01	108.45	248.000	2250.0	471666.666667	True	False	False	True	False	True	False	True	False	False	False	True	False	False	False	False	False	False	2014	68000	4056196	4624000000

	mileage	max_power	torque	max_torque_rpm	name	fuel_Diesel	fuel_LPG	fuel_Petrol	seller_type_Individual	seller_type_Trustmark Dealer	transmission_Manual	owner_Fourth & Above Owner	owner_Second Owner	owner_Test Drive Car	owner_Third Owner	seats_4	seats_5	seats_6	seats_7	seats_8	seats_9	seats_10	seats_14	year	km_driven	year_squared	km_driven_squared
5830	19.70	46.30	62.00	3000.0	151554.527273	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2011	73000	4044121	5329000000
5831	16.10	37.00	59.00	2500.0	68206.862069	False	False	True	True	False	True	False	False	False	False	True	False	False	False	False	False	False	False	1997	120000	3988009	14400000000
5832	23.95	67.10	90.00	3500.0	352666.666667	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2017	45000	4068289	2025000000
5833	18.50	82.85	113.70	4000.0	293749.916667	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2013	25000	4052169	625000000
5834	20.51	67.04	90.00	3500.0	352000.000000	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2017	80000	4068289	6400000000
5835	17.92	62.10	96.10	3000.0	181809.476190	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2008	191000	4032064	36481000000
5836	18.90	67.10	90.00	3500.0	271500.000000	False	False	True	True	False	True	False	True	False	False	False	True	False	False	False	False	False	False	2013	50000	4052169	2500000000
5837	18.50	82.85	113.70	4000.0	298749.916667	False	False	True	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2013	110000	4052169	12100000000
5838	16.80	110.00	235.44	2750.0	236000.000000	True	False	False	True	False	True	True	False	False	False	False	True	False	False	False	False	False	False	2007	119000	4028049	14161000000
5839	19.30	73.90	190.00	2000.0	302272.727273	True	False	False	True	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2009	120000	4036081	14400000000

Duplicate rows

Most frequently occurring

	mileage	max_power	torque	max_torque_rpm	name	fuel_Diesel	fuel_LPG	fuel_Petrol	seller_type_Individual	seller_type_Trustmark Dealer	transmission_Manual	owner_Fourth & Above Owner	owner_Second Owner	owner_Test Drive Car	owner_Third Owner	seats_4	seats_5	seats_6	seats_7	seats_8	seats_9	seats_10	seats_14	year	km_driven	year_squared	km_driven_squared	# duplicates
0	13.70	138.10	320.00	2700.0	522960.091096	True	False	False	True	False	True	False	True	False	False	False	False	False	True	False	False	False	False	2013	80000	4052169	6400000000	2
1	17.70	113.42	144.15	4500.0	522960.091096	False	False	True	False	False	True	False	False	False	False	False	True	False	False	False	False	False	False	2012	60000	4048144	3600000000	2
2	19.37	81.86	160.00	3000.0	522960.091096	False	False	True	True	False	True	False	False	False	True	False	True	False	False	False	False	False	False	2003	120000	4012009	14400000000	2
3	19.37	81.86	160.00	3000.0	522960.091096	False	False	True	True	False	True	False	True	False	False	False	True	False	False	False	False	False	False	2004	120000	4016016	14400000000	2

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring